Del Real Commercial Internal Job Aid · Page One · Industrial
Capture Worksheet

What page one needsThe six dials.

Every dial = 4 inputs
  • 1. The current county figure
  • 2. Its year-over-year change
  • 3. The Central Valley benchmark
  • 4. A 12-month trend series

Page one is six dials and nothing else — so getting these numbers right is the whole job. This sheet defines each metric, tells you exactly what to capture, and gives you a blank worksheet to fill while you're inside CoStar. Capture everything here first, then type it into the report.

The six metrics, defined

Merced County · Industrial · Warehouse & Flex
1
Sales Volume · TTMDial 1
Total dollars of industrial that traded in the county over the trailing 12 months — the size of the market, not the count of deals.
County figure
$ e.g. 96.5M
YoY change
% vs prior 12 mo
CV benchmark
$ Central Valley TTM
CoStar → Markets → Merced → Industrial → Sales, period = Trailing 12 Mo. Cross-check against Crexi sold totals.
2
Median Price / SFDial 2
The middle price per square foot across the quarter's sales — the headline "what space is worth" number. Use median, not average, so one big deal can't skew it.
County figure
$ /SF
YoY change
%
CV benchmark
$ /SF
Median of the Price/SF column in your Sale Comps export (Step 2 of the playbook). Same dataset feeds the page-two comps table.
3
Cap Rate · transaction-weightedDial 3
The blended going-in yield on sales that disclosed one, weighted by sale price so larger deals count more. Many private trades won't report a cap — use only the disclosed subset.
County figure
%
YoY change
pp points
CV benchmark
%
Sale Comps with a disclosed cap rate → weight each by sale price. Note the sample size if it's thin.
4
Avg Asking RentDial 4
Average asking rent per square foot per month across the county's industrial inventory — the income side owners feel first.
County figure
$ /SF·mo
YoY change
%
CV benchmark
$ /SF·mo
CoStar → Industrial → Rent, current quarter, $/SF/mo.
5
Vacancy RateDial 5
Share of industrial space sitting empty county-wide. Lower is tighter — the supply-and-demand read behind rent growth.
County figure
%
YoY change
pp points
CV benchmark
%
CoStar → Industrial → Vacancy, current quarter.
6
Rent Growth · YoYDial 6
How much asking rent moved over the past year. The forward-looking signal — where the income line is heading.
County figure
% YoY
vs CV
pp points
CV benchmark
% YoY
CoStar → Industrial → Rent Growth, 12-month.

This quarter's capture

Fill the gold cells · Q ____ 20 ____

Write the figures here as you pull them, then transfer to the report. The gold cells are what you key in; the trailing-12 series goes in the box below.

Dial County figure YoY change Central Valley Source confirmed
1 · Sales Volume · TTM
2 · Median Price / SF
3 · Cap Rate · txn-wtd
4 · Avg Asking Rent
5 · Vacancy Rate
6 · Rent Growth · YoY

The 12-month trend series

One row per dial · sparklines

Each dial draws a sparkline from twelve monthly values. Read them off the CoStar trend chart and write them left → right. Units don't matter — the line auto-scales to show shape. In the report HTML they live in each dial's data-points="…" attribute. Only have endpoints? A smooth run between them is fine.

M-11
M-10
M-9
M-8
M-7
M-6
M-5
M-4
M-3
M-2
M-1
Now
Watch for

Keep units consistent within a metric (don't mix gross SF with rentable SF). Use pp (percentage points) — not % — for changes in cap rate, vacancy, and rent growth. If a metric's sample is thin this quarter, note it in the read rather than overstating precision.

Del Real Commercial Page One Data · Capture Job Aid DelRealCRE.com